Tabela LDocumentIdentifier

Definicja tabeli LDocumentIdentifier

Name

LDocumentIdentifier

Code

LDocumentIdentifier

Comment

PL: Przyprzadkowanie numeru dla faktury korygujacej
EN: Assignation invoice number for invoice correction


Lista kolumn tabeli LDocumentIdentifier

Name

Code

IdentifierTypeID

IdentifierTypeID

ExternalValue

ExternalValue

DocumentID

DocumentID

Active

Active

InsertingPerson

InsertingPerson

InsertDT

InsertDT

ReceiptNumber

ReceiptNumber

FPNumber

FPNumber

ReceiptPrinted

ReceiptPrinted


Kolumna IdentifierTypeID tabeli LDocumentIdentifier

Definicja kolumny IdentifierTypeID tabeli LDocumentIdentifier

Name

IdentifierTypeID

Code

IdentifierTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ExternalValue tabeli LDocumentIdentifier

Definicja kolumny ExternalValue tabeli LDocumentIdentifier

Name

ExternalValue

Code

ExternalValue

Data Type

VARCHAR2(64)

Mandatory

Yes

Comment

 


Kolumna DocumentID tabeli LDocumentIdentifier

Definicja kolumny DocumentID tabeli LDocumentIdentifier

Name

DocumentID

Code

DocumentID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli LDocumentIdentifier

Definicja kolumny Active tabeli LDocumentIdentifier

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna InsertingPerson tabeli LDocumentIdentifier

Definicja kolumny InsertingPerson tabeli LDocumentIdentifier

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

Osoba, która wygenerowala dana fakture i/lub paragon


Kolumna InsertDT tabeli LDocumentIdentifier

Definicja kolumny InsertDT tabeli LDocumentIdentifier

Name

InsertDT

Code

InsertDT

Data Type

DATE

Mandatory

No

Comment

Data wygenerowania danej faktury i/lub paragonu


Kolumna ReceiptNumber tabeli LDocumentIdentifier

Definicja kolumny ReceiptNumber tabeli LDocumentIdentifier

Name

ReceiptNumber

Code

ReceiptNumber

Data Type

VARCHAR2(16)

Mandatory

No

Comment

Kolumna bedzie przechowywac numer paragonu wygenerowany na drukarce fiskalnej


Kolumna FPNumber tabeli LDocumentIdentifier

Definicja kolumny FPNumber tabeli LDocumentIdentifier

Name

FPNumber

Code

FPNumber

Data Type

VARCHAR2(16)

Mandatory

No

Comment

Numer cechy fiskalnej


Kolumna ReceiptPrinted tabeli LDocumentIdentifier

Definicja kolumny ReceiptPrinted tabeli LDocumentIdentifier

Name

ReceiptPrinted

Code

ReceiptPrinted

Data Type

NUMBER(1)

Mandatory

Yes

Comment

 


Lista kluczy tabeli LDocumentIdentifier

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LDocumentIdentifier

Definicja klucza Identifier_1 tabeli LDocumentIdentifier

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment